<?php

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */


header('Content-type: text/html; charset=latin1');
include("mysqlconfig.inc");
include '../verifica_usuario.php';

$nome_empresa = $_GET["nome"];

$query = "SELECT obras_nome, obras_id FROM OBRAS where EMPRESAS_nome ='$nome_empresa'";
$result = mysql_query($query);
// printing the list box select command

while ($nt = mysql_fetch_array($result)) {//Array or records stored in $nt
    echo "<option value='$nt[obras_nome]'>$nt[obras_nome]</option>";
    /* Option values are added by looping through the array */
}
mysql_close($con);
?>
